delete from CashDrawer_Dtl delete from CashDrawer_Log delete from CashDrawer_Mst delete from appointments_sub_detail delete from appointments_detail delete from appointments_master delete from EndDay_BalancingDtl delete from EndDay_BalancingMst delete from customer_medicalhistory_link delete from HoldSales_Dtl delete from HoldSales_Mst DELETE FROM Log_Detail DELETE FROM Log_MASTER delete from Login_History delete from Payment_Details delete from PettyCash delete from reservedtables delete from Reservation_master delete from sales_subDtl delete from Product_StockList delete from ProductMovement_Dtl delete from ProductMovement_Mst delete from Promotions_Detail delete from Promotions_Master delete from Purchase_Order_Details delete from Purchase_Orders DELETE FROM Purchase_Payment_Details DELETE FROM Purchase_Inv_Entry_Detail DELETE FROM Purchase_Inv_Entry_MASTER update product_master set physical_qty=0,backorder_qty=0 DELETE FROM Purchase_Payment_mASTER DELETE FROM Sales_Payment_Details DELETE FROM Sales_Payment_MASTER DELETE FROM Service_Rooms DELETE FROM Service_Rooms_Linking DELETE FROM Services_Users_Linking DELETE FROM Services_MixedServices DELETE FROM Services_Pricing DELETE FROM Services_Master delete from Refund_Detail delete from Refund_Mst delete from Repacking_Detail delete from Repacking_Master delete from Sales_Dtl delete from Sales_Mst delete from Stock_Transactions delete from StockAdjustment_Dtl delete from StockAdjustmentMaster